At 17:08 +0200 on 22/10/1999, Tom Lane wrote:
> In the meantime, the conventional wisdom is still that you should use
> COPY, if possible, for bulk data loading. (If you need default values
> inserted in some columns then this won't do...)
Yes it would - in two steps. COPY to a temp table that only has the
non-default columns. Then INSERT ... SELECT ... from that temp table to
your "real" table.
Herouth
--
Herouth Maoz, Internet developer.
Open University of Israel - Telem project
http://telem.openu.ac.il/~herutma